Overview

Dataset statistics

Number of variables18
Number of observations869
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory122.3 KiB
Average record size in memory144.1 B

Variable types

NUM17
CAT1

Reproduction

Analysis started2020-06-13 15:26:37.161043
Analysis finished2020-06-13 15:27:52.104370
Duration1 minute and 14.94 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

ZAT is highly correlated with df_indexHigh correlation
df_index is highly correlated with ZATHigh correlation
N_DESTINO is highly correlated with N_ORIGENHigh correlation
N_ORIGEN is highly correlated with N_DESTINOHigh correlation
25-59 is highly correlated with 20-24 and 6 other fieldsHigh correlation
20-24 is highly correlated with 25-59 and 5 other fieldsHigh correlation
5-19 is highly correlated with 20-24 and 5 other fieldsHigh correlation
MEDIA is highly correlated with 20-24 and 5 other fieldsHigh correlation
NINGUNA is highly correlated with 20-24 and 5 other fieldsHigh correlation
SUPERIOR is highly correlated with 25-59 and 1 other fieldsHigh correlation
60+ is highly correlated with SUPERIORHigh correlation
HOMBRE is highly correlated with 20-24 and 5 other fieldsHigh correlation
MUJER is highly correlated with 20-24 and 5 other fieldsHigh correlation
df_index has unique values Unique
ZAT has unique values Unique
N_ORIGEN has 177 (20.4%) zeros Zeros
N_DESTINO has 176 (20.3%) zeros Zeros
ESTRATO has 144 (16.6%) zeros Zeros
CUPOS has 752 (86.5%) zeros Zeros
PARQUEADEROS has 710 (81.7%) zeros Zeros
NINGUNA has 24 (2.8%) zeros Zeros
POSGRADO has 26 (3.0%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count869
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean446.8124280782509
Minimum0
Maximum921
Zeros1
Zeros (%)0.1%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile46.4
Q1224
median448
Q3666
95-th percentile849.6
Maximum921
Range921
Interquartile range (IQR)442

Descriptive statistics

Standard deviation258.2122078
Coefficient of variation (CV)0.577898446
Kurtosis-1.169368386
Mean446.8124281
Median Absolute Deviation (MAD)221
Skewness0.01336040031
Sum388280
Variance66673.54427
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
92110.1%
 
29210.1%
 
30510.1%
 
30410.1%
 
30310.1%
 
30210.1%
 
30110.1%
 
30010.1%
 
29910.1%
 
29810.1%
 
Other values (859)85998.8%
 
ValueCountFrequency (%) 
010.1%
 
110.1%
 
210.1%
 
310.1%
 
410.1%
 
ValueCountFrequency (%) 
92110.1%
 
91910.1%
 
91810.1%
 
91710.1%
 
91610.1%
 

ZAT
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count869
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean467.2819332566168
Minimum1
Maximum1141
Zeros0
Zeros (%)0.0%
Memory size6.8 KiB

Quantile statistics

Minimum1
5-th percentile47.4
Q1225
median449
Q3667
95-th percentile1000.6
Maximum1141
Range1140
Interquartile range (IQR)442

Descriptive statistics

Standard deviation290.5735983
Coefficient of variation (CV)0.621837862
Kurtosis-0.806822074
Mean467.2819333
Median Absolute Deviation (MAD)221
Skewness0.3346302649
Sum406068
Variance84433.01604
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
114110.1%
 
29310.1%
 
30610.1%
 
30510.1%
 
30410.1%
 
30310.1%
 
30210.1%
 
30110.1%
 
30010.1%
 
29910.1%
 
Other values (859)85998.8%
 
ValueCountFrequency (%) 
110.1%
 
210.1%
 
310.1%
 
410.1%
 
510.1%
 
ValueCountFrequency (%) 
114110.1%
 
107010.1%
 
106910.1%
 
106810.1%
 
106710.1%
 

N_ORIGEN
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count690
Unique (%)79.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean944.7838377589818
Minimum0.0
Maximum12494.83348649324
Zeros177
Zeros (%)20.4%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile0
Q172.82267097
median465.4952839
Q31186.811789
95-th percentile3669.699451
Maximum12494.83349
Range12494.83349
Interquartile range (IQR)1113.989118

Descriptive statistics

Standard deviation1454.671114
Coefficient of variation (CV)1.539686705
Kurtosis17.51878753
Mean944.7838378
Median Absolute Deviation (MAD)465.4952839
Skewness3.537384794
Sum821017.155
Variance2116068.051
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
017720.4%
 
156.500796520.2%
 
28.6325186520.2%
 
192.190033820.2%
 
199.170569110.1%
 
767.015078710.1%
 
388.512700610.1%
 
124.715206810.1%
 
2727.34104710.1%
 
4169.69873710.1%
 
Other values (680)68078.3%
 
ValueCountFrequency (%) 
017720.4%
 
2.83551113210.1%
 
5.32223827810.1%
 
14.0777098110.1%
 
14.9777109110.1%
 
ValueCountFrequency (%) 
12494.8334910.1%
 
12198.9798510.1%
 
11355.9114610.1%
 
10596.3237910.1%
 
8703.69934210.1%
 

N_DESTINO
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count692
Unique (%)79.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean940.166239917363
Minimum0.0
Maximum12327.549730943923
Zeros176
Zeros (%)20.3%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile0
Q171.54733971
median494.259481
Q31213.179891
95-th percentile3438.564018
Maximum12327.54973
Range12327.54973
Interquartile range (IQR)1141.632552

Descriptive statistics

Standard deviation1430.842701
Coefficient of variation (CV)1.521903936
Kurtosis17.58564723
Mean940.1662399
Median Absolute Deviation (MAD)494.259481
Skewness3.507784693
Sum817004.4625
Variance2047310.834
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
017620.3%
 
192.190033820.2%
 
388.512700620.2%
 
2202.32530410.1%
 
120.061507610.1%
 
249.430413710.1%
 
1302.20264910.1%
 
1612.80581610.1%
 
837.584228610.1%
 
419.320993410.1%
 
Other values (682)68278.5%
 
ValueCountFrequency (%) 
017620.3%
 
2.2239352810.1%
 
2.83551113210.1%
 
9.76776699210.1%
 
14.0127808510.1%
 
ValueCountFrequency (%) 
12327.5497310.1%
 
11916.57210.1%
 
11520.8538910.1%
 
10810.5853110.1%
 
8002.28668710.1%
 

ESTRATO
Real number (ℝ≥0)

ZEROS

Distinct count7
Unique (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.486766398158803
Minimum0.0
Maximum6.0
Zeros144
Zeros (%)16.6%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile0
Q12
median3
Q33
95-th percentile6
Maximum6
Range6
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.594596945
Coefficient of variation (CV)0.6412331074
Kurtosis-0.3073776538
Mean2.486766398
Median Absolute Deviation (MAD)1
Skewness0.1616909652
Sum2161
Variance2.542739417
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
327631.8%
 
219722.7%
 
014416.6%
 
410011.5%
 
1677.7%
 
6475.4%
 
5384.4%
 
ValueCountFrequency (%) 
014416.6%
 
1677.7%
 
219722.7%
 
327631.8%
 
410011.5%
 
ValueCountFrequency (%) 
6475.4%
 
5384.4%
 
410011.5%
 
327631.8%
 
219722.7%
 

USO
Categorical

Distinct count8
Unique (%)0.9%
Missing0
Missing (%)0.0%
Memory size6.8 KiB
RESIDENCIAL
713
OTROS
 
103
BODEGAS
 
21
OFICINAS
 
15
UNIVERSIDADES Y COLEGIOS
 
7
Other values (3)
 
10
ValueCountFrequency (%) 
RESIDENCIAL71382.0%
 
OTROS10311.9%
 
BODEGAS212.4%
 
OFICINAS151.7%
 
UNIVERSIDADES Y COLEGIOS70.8%
 
COMERCIO70.8%
 
INDUSTRIA20.2%
 
CLINICAS, HOSPITALES, CENTROS MEDICOS10.1%
 

Length

Max length37
Median length11
Mean length10.24626007
Min length5

CUPOS
Real number (ℝ≥0)

ZEROS

Distinct count77
Unique (%)8.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.627157652474109
Minimum0.0
Maximum785.0
Zeros752
Zeros (%)86.5%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile96
Maximum785
Range785
Interquartile range (IQR)0

Descriptive statistics

Standard deviation67.78208849
Coefficient of variation (CV)4.337454705
Kurtosis59.51133888
Mean15.62715765
Median Absolute Deviation (MAD)0
Skewness7.021085544
Sum13580
Variance4594.41152
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
075286.5%
 
12151.7%
 
2250.6%
 
4840.5%
 
2030.3%
 
3830.3%
 
6030.3%
 
5020.2%
 
10020.2%
 
1520.2%
 
Other values (67)789.0%
 
ValueCountFrequency (%) 
075286.5%
 
12151.7%
 
1310.1%
 
1420.2%
 
1520.2%
 
ValueCountFrequency (%) 
78510.1%
 
72010.1%
 
71010.1%
 
56810.1%
 
53210.1%
 

PARQUEADEROS
Real number (ℝ≥0)

ZEROS

Distinct count13
Unique (%)1.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.44994246260069043
Minimum0.0
Maximum15.0
Zeros710
Zeros (%)81.7%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile3
Maximum15
Range15
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.369126541
Coefficient of variation (CV)3.042892491
Kurtosis36.09729195
Mean0.4499424626
Median Absolute Deviation (MAD)0
Skewness5.193863619
Sum391
Variance1.874507485
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
071081.7%
 
1738.4%
 
2364.1%
 
3232.6%
 
470.8%
 
660.7%
 
550.6%
 
820.2%
 
920.2%
 
720.2%
 
Other values (3)30.3%
 
ValueCountFrequency (%) 
071081.7%
 
1738.4%
 
2364.1%
 
3232.6%
 
470.8%
 
ValueCountFrequency (%) 
1510.1%
 
1310.1%
 
1210.1%
 
920.2%
 
820.2%
 

20-24
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count682
Unique (%)78.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean868.5707710011508
Minimum0.0
Maximum7132.0
Zeros3
Zeros (%)0.3%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile11.4
Q1203
median536
Q31175
95-th percentile2768.8
Maximum7132
Range7132
Interquartile range (IQR)972

Descriptive statistics

Standard deviation981.4787084
Coefficient of variation (CV)1.129992789
Kurtosis7.352009216
Mean868.570771
Median Absolute Deviation (MAD)402
Skewness2.311946771
Sum754788
Variance963300.455
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
4121.4%
 
280.9%
 
160.7%
 
15240.5%
 
41440.5%
 
45430.3%
 
030.3%
 
39930.3%
 
1330.3%
 
20130.3%
 
Other values (672)82094.4%
 
ValueCountFrequency (%) 
030.3%
 
160.7%
 
280.9%
 
320.2%
 
4121.4%
 
ValueCountFrequency (%) 
713210.1%
 
702910.1%
 
577110.1%
 
573410.1%
 
550910.1%
 

25-59
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count818
Unique (%)94.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4564.827387802071
Minimum0.0
Maximum35334.0
Zeros1
Zeros (%)0.1%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile69.6
Q11168
median3012
Q36312
95-th percentile14592.8
Maximum35334
Range35334
Interquartile range (IQR)5144

Descriptive statistics

Standard deviation4839.297346
Coefficient of variation (CV)1.060127127
Kurtosis5.943113293
Mean4564.827388
Median Absolute Deviation (MAD)2214
Skewness2.077523778
Sum3966835
Variance23418798.8
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2140.5%
 
8930.3%
 
324530.3%
 
119120.2%
 
47520.2%
 
7520.2%
 
247420.2%
 
479920.2%
 
125820.2%
 
282920.2%
 
Other values (808)84597.2%
 
ValueCountFrequency (%) 
010.1%
 
410.1%
 
520.2%
 
610.1%
 
920.2%
 
ValueCountFrequency (%) 
3533410.1%
 
2964410.1%
 
2921510.1%
 
2712210.1%
 
2667610.1%
 

5-19
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count763
Unique (%)87.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1856.7502876869964
Minimum0.0
Maximum16906.0
Zeros1
Zeros (%)0.1%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile35
Q1366
median1052
Q32548
95-th percentile5964.8
Maximum16906
Range16906
Interquartile range (IQR)2182

Descriptive statistics

Standard deviation2202.229226
Coefficient of variation (CV)1.186066452
Kurtosis8.427927685
Mean1856.750288
Median Absolute Deviation (MAD)841
Skewness2.450172628
Sum1613516
Variance4849813.563
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
270.8%
 
750.6%
 
4640.5%
 
1430.3%
 
3530.3%
 
1930.3%
 
5730.3%
 
28030.3%
 
22830.3%
 
130.3%
 
Other values (753)83295.7%
 
ValueCountFrequency (%) 
010.1%
 
130.3%
 
270.8%
 
420.2%
 
520.2%
 
ValueCountFrequency (%) 
1690610.1%
 
1589210.1%
 
1272210.1%
 
1266510.1%
 
1247210.1%
 

60+
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count711
Unique (%)81.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1170.14499424626
Minimum0.0
Maximum7654.0
Zeros2
Zeros (%)0.2%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile13.4
Q1325
median858
Q31695
95-th percentile3385.2
Maximum7654
Range7654
Interquartile range (IQR)1370

Descriptive statistics

Standard deviation1102.997532
Coefficient of variation (CV)0.9426161178
Kurtosis2.992686669
Mean1170.144994
Median Absolute Deviation (MAD)619
Skewness1.5105982
Sum1016856
Variance1216603.555
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
291.0%
 
580.9%
 
2350.6%
 
740.5%
 
140.5%
 
78040.5%
 
440.5%
 
142840.5%
 
2440.5%
 
3540.5%
 
Other values (701)81994.2%
 
ValueCountFrequency (%) 
020.2%
 
140.5%
 
291.0%
 
330.3%
 
440.5%
 
ValueCountFrequency (%) 
765410.1%
 
597710.1%
 
566710.1%
 
561710.1%
 
559510.1%
 

MEDIA
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count817
Unique (%)94.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4968.350978135788
Minimum0.0
Maximum45419.0
Zeros2
Zeros (%)0.2%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile52.4
Q1817
median2717
Q36939
95-th percentile16842
Maximum45419
Range45419
Interquartile range (IQR)6122

Descriptive statistics

Standard deviation6191.537257
Coefficient of variation (CV)1.246195626
Kurtosis8.206675264
Mean4968.350978
Median Absolute Deviation (MAD)2274
Skewness2.465831841
Sum4317497
Variance38335133.61
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1540.5%
 
340.5%
 
7230.3%
 
72630.3%
 
2130.3%
 
3030.3%
 
25320.2%
 
331120.2%
 
295920.2%
 
10120.2%
 
Other values (807)84196.8%
 
ValueCountFrequency (%) 
020.2%
 
340.5%
 
410.1%
 
520.2%
 
610.1%
 
ValueCountFrequency (%) 
4541910.1%
 
4361110.1%
 
3767210.1%
 
3608110.1%
 
3547110.1%
 

NINGUNA
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count342
Unique (%)39.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean138.228998849252
Minimum0.0
Maximum1034.0
Zeros24
Zeros (%)2.8%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile2
Q137
median93
Q3191
95-th percentile434
Maximum1034
Range1034
Interquartile range (IQR)154

Descriptive statistics

Standard deviation142.8258802
Coefficient of variation (CV)1.03325555
Kurtosis4.767976074
Mean138.2289988
Median Absolute Deviation (MAD)67
Skewness1.893161917
Sum120121
Variance20399.23206
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0242.8%
 
1161.8%
 
2111.3%
 
3101.2%
 
491.0%
 
3891.0%
 
1391.0%
 
3580.9%
 
7480.9%
 
5280.9%
 
Other values (332)75787.1%
 
ValueCountFrequency (%) 
0242.8%
 
1161.8%
 
2111.3%
 
3101.2%
 
491.0%
 
ValueCountFrequency (%) 
103410.1%
 
85310.1%
 
79810.1%
 
79510.1%
 
73010.1%
 

POSGRADO
Real number (ℝ≥0)

ZEROS

Distinct count534
Unique (%)61.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean524.3325661680092
Minimum0.0
Maximum5160.0
Zeros26
Zeros (%)3.0%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile2
Q152
median207
Q3596
95-th percentile2364.8
Maximum5160
Range5160
Interquartile range (IQR)544

Descriptive statistics

Standard deviation801.0081356
Coefficient of variation (CV)1.527671915
Kurtosis7.547539893
Mean524.3325662
Median Absolute Deviation (MAD)190
Skewness2.592524364
Sum455645
Variance641614.0333
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0263.0%
 
1131.5%
 
3101.2%
 
491.0%
 
591.0%
 
291.0%
 
880.9%
 
1070.8%
 
1170.8%
 
660.7%
 
Other values (524)76588.0%
 
ValueCountFrequency (%) 
0263.0%
 
1131.5%
 
291.0%
 
3101.2%
 
491.0%
 
ValueCountFrequency (%) 
516010.1%
 
485610.1%
 
464210.1%
 
446410.1%
 
443710.1%
 

SUPERIOR
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count790
Unique (%)90.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2633.9113924050635
Minimum0.0
Maximum21871.0
Zeros1
Zeros (%)0.1%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile33
Q1671
median1744
Q33634
95-th percentile8664
Maximum21871
Range21871
Interquartile range (IQR)2963

Descriptive statistics

Standard deviation2837.499961
Coefficient of variation (CV)1.077295147
Kurtosis6.70029891
Mean2633.911392
Median Absolute Deviation (MAD)1266
Skewness2.130007367
Sum2288869
Variance8051406.03
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
650.6%
 
350.6%
 
240.5%
 
430.3%
 
1130.3%
 
2230.3%
 
5730.3%
 
137130.3%
 
184930.3%
 
61520.2%
 
Other values (780)83596.1%
 
ValueCountFrequency (%) 
010.1%
 
120.2%
 
240.5%
 
350.6%
 
430.3%
 
ValueCountFrequency (%) 
2187110.1%
 
2074310.1%
 
1760510.1%
 
1589510.1%
 
1425610.1%
 

HOMBRE
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count823
Unique (%)94.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4280.853855005754
Minimum0.0
Maximum32453.0
Zeros1
Zeros (%)0.1%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile68.8
Q11083
median2785
Q36045
95-th percentile12987
Maximum32453
Range32453
Interquartile range (IQR)4962

Descriptive statistics

Standard deviation4560.571956
Coefficient of variation (CV)1.065341661
Kurtosis6.115608155
Mean4280.853855
Median Absolute Deviation (MAD)2105
Skewness2.105020196
Sum3720062
Variance20798816.57
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1950.6%
 
137030.3%
 
9130.3%
 
133120.2%
 
1520.2%
 
97720.2%
 
145020.2%
 
6220.2%
 
250020.2%
 
201520.2%
 
Other values (813)84497.1%
 
ValueCountFrequency (%) 
010.1%
 
520.2%
 
620.2%
 
710.1%
 
810.1%
 
ValueCountFrequency (%) 
3245310.1%
 
3038810.1%
 
2567010.1%
 
2547410.1%
 
2505610.1%
 

MUJER
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count820
Unique (%)94.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4697.983889528194
Minimum0.0
Maximum35785.0
Zeros1
Zeros (%)0.1%
Memory size6.8 KiB

Quantile statistics

Minimum0
5-th percentile64
Q11164
median3103
Q36609
95-th percentile14409.2
Maximum35785
Range35785
Interquartile range (IQR)5445

Descriptive statistics

Standard deviation4974.68218
Coefficient of variation (CV)1.058897241
Kurtosis5.788533531
Mean4697.98389
Median Absolute Deviation (MAD)2306
Skewness2.051922371
Sum4082548
Variance24747462.79
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1740.5%
 
3130.3%
 
830.3%
 
6430.3%
 
66030.3%
 
1530.3%
 
16030.3%
 
4720.2%
 
146220.2%
 
1820.2%
 
Other values (810)84196.8%
 
ValueCountFrequency (%) 
010.1%
 
310.1%
 
410.1%
 
610.1%
 
710.1%
 
ValueCountFrequency (%) 
3578510.1%
 
3149910.1%
 
2775710.1%
 
2738610.1%
 
2725810.1%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

df_indexZATN_ORIGENN_DESTINOESTRATOUSOCUPOSPARQUEADEROS20-2425-595-1960+MEDIANINGUNAPOSGRADOSUPERIORHOMBREMUJER
00172.82267172.8226715.0RESIDENCIAL0.00.040.0211.092.075.0153.01.077.0170.0203.0230.0
1120.0000000.0000006.0RESIDENCIAL0.00.015.0141.080.032.0100.04.041.0118.0130.0147.0
2230.0000000.0000006.0OTROS0.00.034.0180.063.058.0128.02.026.0114.0172.0176.0
3340.0000000.0000000.0OTROS164.00.08.030.06.013.011.02.07.027.031.026.0
4450.0000000.0000004.0OTROS0.00.04.021.07.02.015.00.00.03.019.017.0
567460.092441433.8702062.0COMERCIO0.02.0199.0933.0391.0158.01065.030.017.0508.0880.0918.0
6780.0000000.0000000.0OTROS0.00.050.0237.086.067.0167.08.063.0174.0230.0225.0
7891525.6775701347.1619304.0RESIDENCIAL720.03.01830.09905.02836.03196.05414.0226.02582.09184.08472.09972.0
89100.0000000.0000000.0BODEGAS0.00.0259.01233.0413.0606.0638.033.0429.01285.01197.01376.0
910114731.6992854751.4368233.0RESIDENCIAL0.00.02880.014412.05171.03475.014590.0358.01504.08712.013051.014387.0

Last rows

df_indexZATN_ORIGENN_DESTINOESTRATOUSOCUPOSPARQUEADEROS20-2425-595-1960+MEDIANINGUNAPOSGRADOSUPERIORHOMBREMUJER
85990110520.0000000.0000000.0OTROS0.00.017.068.043.09.0101.04.01.026.065.088.0
86090210530.0000000.0000000.0OTROS0.00.02.027.014.04.022.00.00.04.024.029.0
86190810590.0000000.0000000.0OTROS0.00.04.021.07.02.015.00.00.03.019.017.0
86291210630.0000000.0000004.0OTROS0.00.04.021.07.02.015.00.00.03.019.017.0
863914106590.34133790.3413370.0OTROS0.00.0127.0557.0284.081.0751.016.09.0235.0553.0591.0
86491610670.0000000.0000002.0RESIDENCIAL0.00.04.089.046.05.072.01.04.057.091.064.0
86591710680.0000000.0000000.0OTROS0.00.02.075.035.02.051.01.04.049.076.049.0
86691810690.0000000.0000000.0UNIVERSIDADES Y COLEGIOS0.00.025.0261.0167.031.0189.03.0107.0172.0243.0266.0
867919107039.68647339.6864736.0UNIVERSIDADES Y COLEGIOS0.00.0163.01034.0604.0108.0680.039.0423.0596.0977.01042.0
86892111410.0000000.0000001.0RESIDENCIAL0.00.0550.02095.01173.0316.03311.0111.011.0512.02149.02352.0